package com.bdqn.mzc.mapper;

import com.bdqn.mzc.model.Scenicspot;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ScenicspotMapper {
    /**
     * 查询scenicspot表共有多少数据
     * @return
     */
    int sumScenicsPot();

    /**
     * 根据下单数量查询
     * @return
     */
    List<Scenicspot> selectScenicsPotByorderQuantity();

    /**
     * 根据评分查询
     * @return
     */
    List<Scenicspot> selectScenicsPotByGrade();

    /**
     * 查询所有数据
     * @return
     */
    List<Scenicspot> selectScenicsPotAll();

    /**
     * 根据未知条件查询数据
     * @return
     */
    List<Scenicspot> selectScenicsPotByUnknown
    (@Param("regionId") String[] regionid,
     @Param("scenicspotgrade") String[] scenicspotgrade,
     @Param("scenicspotaddress") String[] scenicspotaddress,
     @Param("scenicspotimgscore")String[] scenicspotimgscore,
     @Param("scenicspotordersquantity")String[] scenicspotordersquantity,
     @Param("scenicspotprice")String[] scenicspotprice,
     @Param("scenicspotopentime")String[] scenicspotopentime
    );

    /**
     * 根据景区名称模糊查询
     * @return
     */
    List<Scenicspot> slectScenicspotByNameLink(String scenicspotscenicname);

    /**
     * 根据id查询一条数据
     * @param id
     * @return
     */
    Scenicspot selectScenicspotById(Integer id);

}
